﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace Vara.Utility
{
    public interface ISqlEngine : IDisposable
    {
        string ConnectionStringName { get; set; }
        DataTable ExecuteProcedure(string name);
        DataTable ExecuteProcedure(string name, params ISqlEngineVariable[] variable);

        bool ProcedureContainsData(string name);
        bool ProcedureContainsData(string name, params ISqlEngineVariable[] variable);

        DataRow ReturnProcedureRow(string name);
        DataRow ReturnProcedureRow(string name,int row);
        DataRow ReturnProcedureRow(string name, params ISqlEngineVariable[] variable);
        DataRow ReturnProcedureRow(string name,int row, params ISqlEngineVariable[] variable);
    }
}
